package com.opal.system.entity.table;

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Random;

@Data
public class QCTlevm {
    //主键
    private String nos;

    //组织
    @Excel(name = "组织",width = 30)
    private String pkOrg;

    //品号
    @Excel(name = "品号")
    private String remark1;

    //品名
    @Excel(name = "品名")
    private String remark2;

    //规格
    @Excel(name = "规格")
    private String remark3;

    //单位
    @Excel(name = "单位")
    private String remark4;

    //批号
    @Excel(name = "批号")
    private String remark5;

    //数量
    @Excel(name = "品号",width = 30)
    private String remark6;

    //不合格类型
    @Excel(name = "不合格类型")
    private String remark7;

    //日期
    @Excel(name = "日期")
    private String dates;

    //日期结束范围
    private String endDates;

    //配方号
    @Excel(name = "配方号")
    private String pfh;

    //供/客
    @Excel(name = "供/客")
    private String customer;

    //报告编号
    @Excel(name = "品号")
    private String repno;

    //报告编号
    @Excel(name = "报告编号")
    private String repno2;

    //报告链接
    @Excel(name = "报告链接",width = 30)
    private String ljaddr;

    //措施完成情况
    @Excel(name = "措施完成情况",width = 30)
    private String cscomplete;

    //调查链接
    @Excel(name = "调查链接",width = 30)
    private String dcaddr;

    //发现环节
    @Excel(name = "发现环节")
    private String bmbh;

    //主要不良
    @Excel(name = "主要不良")
    private String resource;

    //处理方法
    @Excel(name = "处理方法")
    private String smast;

    //处理结果
    @Excel(name = "处理结果")
    private String dmast;

    //出报告时间
    @Excel(name = "出报告时间")
    private String wdate;

    //分发报告时间
    @Excel(name = "分发报告时间")
    private String sdate;

    //不合格等级
    @Excel(name = "不合格等级")
    private String badlev;

    //异常类型(代码)
    @Excel(name = "异常类型(代码)")
    private String badcode;

    //实际工时
    @Excel(name = "实际工时")
    private String times;

    //预计工时
    @Excel(name = "预计工时")
    private String etimes;

    //责任部门
    @Excel(name = "责任部门")
    private String dutydepart;

    //删除状态(默认状态为"1",删除状态为"2")
    private Integer status;

    //备注
    @Excel(name = "备注")
    private String remark;

    public String  getUniqueNos(){
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS");
        String str = sdf.format(new Date());
        return str+new Random().nextInt(1000);
    }
}